Introduction: While migrating Cases, the migration of activities of type ‘Case Resolution’ is necessary. However, the complexity in migrating this increases due to the fact that when the status of a case is updated, a blank case resolution activity is created automatically by the system. This system-generated case resolution needs to be deleted as this … Continue reading Migrating Activities Of Type ‘Case Resolution’ Between Two Microsoft Dynamics CRM Environments →

Introduction: Recently, we encountered an error while integrating Sales Orders from Salesforce to Microsoft Dynamics NAV via Scribe displaying the following error message. Error Details: “The Sales Header Extension does not exist. Identification fields and values: Document Type=’Quote’, No=’ ‘ ” Reason for the error: Upon further debugging, we found that a field in the … Continue reading Scribe Error while integrating from Salesforce to Microsoft Dynamics NAV →

Introduction: Once a User exports a report to Microsoft Excel from a Microsoft Dynamics CRM environment, they may want to further filter the report in Microsoft Excel. Issue: An issue I came across recently was that the report, when exported to Excel, would not allow me to filter in Excel for the first few columns, … Continue reading Filter Error In Excel While Exporting SSRS Report From D365 CRM To Excel →

Introduction The September 2018 Update of Power BI has finally brought to users, the functionality to copy data from a table or matrix in a report. This has been a much-requested feature as one often finds themselves needing to copy a value or columns of data from a report with no option to do so. … Continue reading Copying Data From A Table/Matrix in Power BI : September 2018 Update →

The September update of Power BI features an important functionality: the option to drillthough to another page in that report. For example, if a user wants to see detailed data of a product ‘Product 2’, then they can right-click on Product 2 in the main report, select ‘Drillthrough’ and the relevant sub-report to have it … Continue reading Power BI September 2018 Update: Drillthrough To Another Report Page →

Issue: While trying to integrate records from SFDC to Dynamics NAV 2017, I faced an issue in Scribe saying “The record already exists.”. When I checked in Dynamics NAV 2017, there were no records similar to the one I was trying to integrate when the error occurred. Additionally, when I tried to create a new … Continue reading Microsoft Dynamics NAV 2017 Error: “The record already exists” →

In the August 2018 update of Power BI, we can now apply conditional formatting based on field value. This allows us to use a measure or column that contains a color name, a hex name/code and apply that color to the background of the cells and the font in the cells of that column. For … Continue reading Conditional Formatting By Values in Power BI: August Update →

Introduction: While migrating Email Activities from D365 v8.2 to v9, I came across the following error: “Operation failed. Label: Create email, Name: emailCreate2, Message: -2147220969: ActivityPointer With Id = XXXXXXXXXXXX Does Not Exist” This can cause some confusion as activitypointers do not need to be migrated before you begin migrating emails. What are ActivityPointers? The … Continue reading Error During Email Activity Migration: ActivityPointer Does Not Exist →

Introduction: PowerBI introduced the feature to format line styles and legends for line charts a while ago. However, these features were not applicable to lines in combination charts like ‘Line and Stacked Column Chart’ and ‘Line and Clustered Column Chart’. With the April update of PowerBI Desktop, we are now able to customise the format … Continue reading PowerBI April 2018 Update: Combo Chart Line Formatting →

Introduction: With the latest update of Power BI, you can now ask top-n type questions and get answers based on your dataset. Questions like ‘What are the top 3 products by sales?’ or ‘Top Manufacturer by country’ are examples. This is also valid for bottom-n type questions like ‘Least selling product in a country’. Steps: … Continue reading Top-N Questions & Answers in Power BI →